<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">
	<meta name="robots" content="noindex">

	<title>File Slimore/Pagination/Paginator.php | Slimore</title>

	<link rel="stylesheet" href="resources/bootstrap.min.css?973e37a8502921d56bc02bb55321f45b072b6f71">
	<link rel="stylesheet" href="resources/style.css?49f43d3208c5d7e33fa16d36107a345bf11cc00d">

</head>

<body>
	<nav id="navigation" class="navbar navbar-default navbar-fixed-top">
		<div class="container-fluid">
			<div class="navbar-header">
				<a href="index.html" class="navbar-brand">Slimore</a>
			</div>
			<div class="collapse navbar-collapse">

                <form id="search" class="navbar-form navbar-left" role="search">
                    <input type="hidden" name="cx" value="">
                    <input type="hidden" name="ie" value="UTF-8">
                    <div class="form-group">
                        <input type="text" name="q" class="search-query form-control" placeholder="Search">
					</div>
				</form>

				<ul class="nav navbar-nav">
					<li>
<span>Namespace</span>					</li>
					<li>
<span>Class</span>					</li>





				</ul>
			</div>
		</div>
	</nav>

	<div id="left">
	<div id="menu">

		<div id="groups">
				<h3>Namespaces</h3>
			<ul>
					<li>
						<a href="namespace-None.html">
							None						</a>
							</li>
					<li>
						<a href="namespace-Slimore.html">
							Slimore<span></span>
						</a>
							<ul>
					<li>
						<a href="namespace-Slimore.Cache.html">
							Cache<span></span>
						</a>
							<ul>
					<li>
						<a href="namespace-Slimore.Cache.Exception.html">
							Exception						</a>
							</li>
								</ul></li>
					<li>
						<a href="namespace-Slimore.Captcha.html">
							Captcha						</a>
							</li>
					<li>
						<a href="namespace-Slimore.Database.html">
							Database						</a>
							</li>
					<li>
						<a href="namespace-Slimore.Debug.html">
							Debug						</a>
							</li>
					<li>
						<a href="namespace-Slimore.Http.html">
							Http						</a>
							</li>
					<li>
						<a href="namespace-Slimore.Image.html">
							Image						</a>
							</li>
					<li>
						<a href="namespace-Slimore.Log.html">
							Log						</a>
							</li>
					<li>
						<a href="namespace-Slimore.Middleware.html">
							Middleware						</a>
							</li>
					<li>
						<a href="namespace-Slimore.Mvc.html">
							Mvc						</a>
							</li>
					<li>
						<a href="namespace-Slimore.Pagination.html">
							Pagination						</a>
							</li>
					<li>
						<a href="namespace-Slimore.Upload.html">
							Upload						</a>
							</li>
								</ul></li>
			</ul>
		</div>


		<div id="elements">
			<h3>Classes</h3>
			<ul>
				<li><a href="class-Slimore.Cache.File.html">Slimore\Cache\File</a></li>
				<li><a href="class-Slimore.Captcha.Builder.html">Slimore\Captcha\Builder</a></li>
				<li><a href="class-Slimore.Database.Manager.html">Slimore\Database\Manager</a></li>
				<li><a href="class-Slimore.Debug.Simpler.html">Slimore\Debug\Simpler</a></li>
				<li><a href="class-Slimore.Http.Client.html">Slimore\Http\Client</a></li>
				<li><a href="class-Slimore.Image.Gd.html">Slimore\Image\Gd</a></li>
				<li><a href="class-Slimore.Log.Writer.html">Slimore\Log\Writer</a></li>
				<li><a href="class-Slimore.Middleware.Exceptions.html">Slimore\Middleware\Exceptions</a></li>
				<li><a href="class-Slimore.Mvc.Application.html">Slimore\Mvc\Application</a></li>
				<li><a href="class-Slimore.Mvc.Controller.html">Slimore\Mvc\Controller</a></li>
				<li><a href="class-Slimore.Mvc.Model.html">Slimore\Mvc\Model</a></li>
				<li><a href="class-Slimore.Mvc.View.html">Slimore\Mvc\View</a></li>
				<li><a href="class-Slimore.Pagination.Paginator.html">Slimore\Pagination\Paginator</a></li>
				<li><a href="class-Slimore.Upload.Uploader.html">Slimore\Upload\Uploader</a></li>
			</ul>



			<h3>Exceptions</h3>
			<ul>
				<li><a href="class-Slimore.Cache.Exception.File.html">Slimore\Cache\Exception\File</a></li>
				<li><a href="class-Slimore.Captcha.Exception.html">Slimore\Captcha\Exception</a></li>
				<li><a href="class-Slimore.Database.Exception.html">Slimore\Database\Exception</a></li>
				<li><a href="class-Slimore.Http.Exception.html">Slimore\Http\Exception</a></li>
				<li><a href="class-Slimore.Mvc.Exception.html">Slimore\Mvc\Exception</a></li>
				<li><a href="class-Slimore.Pagination.Exception.html">Slimore\Pagination\Exception</a></li>
				<li><a href="class-Slimore.Upload.Exception.html">Slimore\Upload\Exception</a></li>
			</ul>


			<h3>Functions</h3>
			<ul>
				<li><a href="function-arrayToObject.html">arrayToObject</a></li>
				<li><a href="function-console.html">console</a></li>
				<li><a href="function-controller.html">controller</a></li>
				<li><a href="function-ctl.html">ctl</a></li>
				<li><a href="function-currentUrl.html">currentUrl</a></li>
				<li><a href="function-decrypt.html">decrypt</a></li>
				<li><a href="function-detectDevice.html">detectDevice</a></li>
				<li><a href="function-encrypt.html">encrypt</a></li>
				<li><a href="function-fileFormatSize.html">fileFormatSize</a></li>
				<li><a href="function-getDirectoryItems.html">getDirectoryItems</a></li>
				<li><a href="function-getDpi.html">getDpi</a></li>
				<li><a href="function-hexToRGB.html">hexToRGB</a></li>
				<li><a href="function-html.html">html</a></li>
				<li><a href="function-imageDataUrl.html">imageDataUrl</a></li>
				<li><a href="function-iPad.html">iPad</a></li>
				<li><a href="function-iPhone.html">iPhone</a></li>
				<li><a href="function-iPod.html">iPod</a></li>
				<li><a href="function-isAndroid.html">isAndroid</a></li>
				<li><a href="function-isApache.html">isApache</a></li>
				<li><a href="function-isBlackberry.html">isBlackberry</a></li>
				<li><a href="function-isChrome.html">isChrome</a></li>
				<li><a href="function-isCli.html">isCli</a></li>
				<li><a href="function-isFirefox.html">isFirefox</a></li>
				<li><a href="function-isFreeBSD.html">isFreeBSD</a></li>
				<li><a href="function-isIE.html">isIE</a></li>
				<li><a href="function-isIIS.html">isIIS</a></li>
				<li><a href="function-isJson.html">isJson</a></li>
				<li><a href="function-isLinux.html">isLinux</a></li>
				<li><a href="function-isMacOSX.html">isMacOSX</a></li>
				<li><a href="function-isMobile.html">isMobile</a></li>
				<li><a href="function-isNginx.html">isNginx</a></li>
				<li><a href="function-isOpera.html">isOpera</a></li>
				<li><a href="function-isSafari.html">isSafari</a></li>
				<li><a href="function-isTablet.html">isTablet</a></li>
				<li><a href="function-isUnix.html">isUnix</a></li>
				<li><a href="function-isUnixLike.html">isUnixLike</a></li>
				<li><a href="function-isWebOS.html">isWebOS</a></li>
				<li><a href="function-isWindows.html">isWindows</a></li>
				<li><a href="function-js.html">js</a></li>
				<li><a href="function-jsonToArray.html">jsonToArray</a></li>
				<li><a href="function-linkTag.html">linkTag</a></li>
				<li><a href="function-password.html">password</a></li>
				<li><a href="function-phoneMaskCode.html">phoneMaskCode</a></li>
				<li><a href="function-randomCharacters.html">randomCharacters</a></li>
				<li><a href="function-replaceDirSeparator.html">replaceDirSeparator</a></li>
				<li><a href="function-rgbToHex.html">rgbToHex</a></li>
				<li><a href="function-script.html">script</a></li>
				<li><a href="function-shortUrl.html">shortUrl</a></li>
				<li><a href="function-style.html">style</a></li>
			</ul>
		</div>
	</div>
</div>

<div id="splitter"></div>

<div id="right">
	<div id="rightInner">
<pre id="source"><code><span id="1" class="l"><a href="#1">  1 </a><span class="xlang">&lt;?php</span>
</span><span id="2" class="l"><a href="#2">  2 </a>
</span><span id="3" class="l"><a href="#3">  3 </a><span class="php-comment">/**
</span></span><span id="4" class="l"><a href="#4">  4 </a><span class="php-comment"> * Slimore - The fully (H)MVC framework based on the Slim PHP framework.
</span></span><span id="5" class="l"><a href="#5">  5 </a><span class="php-comment"> *
</span></span><span id="6" class="l"><a href="#6">  6 </a><span class="php-comment"> * @author      Pandao &lt;slimore@ipandao.com&gt;
</span></span><span id="7" class="l"><a href="#7">  7 </a><span class="php-comment"> * @copyright   2015 Pandao
</span></span><span id="8" class="l"><a href="#8">  8 </a><span class="php-comment"> * @link        http://github.com/slimore/slimore
</span></span><span id="9" class="l"><a href="#9">  9 </a><span class="php-comment"> * @license     MIT License https://github.com/slimore/slimore#license
</span></span><span id="10" class="l"><a href="#10"> 10 </a><span class="php-comment"> * @version     0.1.0
</span></span><span id="11" class="l"><a href="#11"> 11 </a><span class="php-comment"> * @package     Slimore\Pagination
</span></span><span id="12" class="l"><a href="#12"> 12 </a><span class="php-comment"> */</span>
</span><span id="13" class="l"><a href="#13"> 13 </a>
</span><span id="14" class="l"><a href="#14"> 14 </a><span class="php-keyword1">namespace</span> Slimore\Pagination;
</span><span id="15" class="l"><a href="#15"> 15 </a>
</span><span id="16" class="l"><a href="#16"> 16 </a><span class="php-keyword1">use</span> \Slimore\Debug <span class="php-keyword1">as</span> Debug;
</span><span id="17" class="l"><a href="#17"> 17 </a>
</span><span id="18" class="l"><a href="#18"> 18 </a><span class="php-comment">/**
</span></span><span id="19" class="l"><a href="#19"> 19 </a><span class="php-comment"> * Class Paginator
</span></span><span id="20" class="l"><a href="#20"> 20 </a><span class="php-comment"> *
</span></span><span id="21" class="l"><a href="#21"> 21 </a><span class="php-comment"> * @author Pandao
</span></span><span id="22" class="l"><a href="#22"> 22 </a><span class="php-comment"> * @updateTime 2015-06-05 23:55:05
</span></span><span id="23" class="l"><a href="#23"> 23 </a><span class="php-comment"> * @package Slimore\Pagination
</span></span><span id="24" class="l"><a href="#24"> 24 </a><span class="php-comment"> */</span>
</span><span id="25" class="l"><a href="#25"> 25 </a>
</span><span id="26" class="l"><a href="#26"> 26 </a><span class="php-keyword1">class</span> Paginator
</span><span id="27" class="l"><a href="#27"> 27 </a>{
</span><span id="28" class="l"><a href="#28"> 28 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$sql</span>;
</span><span id="29" class="l"><a href="#29"> 29 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$num</span>;
</span><span id="30" class="l"><a href="#30"> 30 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$page</span>;
</span><span id="31" class="l"><a href="#31"> 31 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$prev</span>;
</span><span id="32" class="l"><a href="#32"> 32 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$next</span>;
</span><span id="33" class="l"><a href="#33"> 33 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$last</span>;
</span><span id="34" class="l"><a href="#34"> 34 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$first</span>;
</span><span id="35" class="l"><a href="#35"> 35 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$total</span>;
</span><span id="36" class="l"><a href="#36"> 36 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$range</span>;
</span><span id="37" class="l"><a href="#37"> 37 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$ranges</span>;
</span><span id="38" class="l"><a href="#38"> 38 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$offset</span>;
</span><span id="39" class="l"><a href="#39"> 39 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$pageTotal</span>;
</span><span id="40" class="l"><a href="#40"> 40 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$baseUrl</span> = <span class="php-quote">''</span>;
</span><span id="41" class="l"><a href="#41"> 41 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$select</span>  = <span class="php-quote">'*'</span>;
</span><span id="42" class="l"><a href="#42"> 42 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$where</span>   = [];
</span><span id="43" class="l"><a href="#43"> 43 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$orderBy</span> = <span class="php-quote">'id'</span>;
</span><span id="44" class="l"><a href="#44"> 44 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$sortBy</span>  = <span class="php-quote">'ASC'</span>;
</span><span id="45" class="l"><a href="#45"> 45 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$model</span>;
</span><span id="46" class="l"><a href="#46"> 46 </a>    <span class="php-keyword1">public</span>  <span class="php-var">$query</span>;
</span><span id="47" class="l"><a href="#47"> 47 </a>    <span class="php-keyword1">private</span> <span class="php-var">$params</span>;
</span><span id="48" class="l"><a href="#48"> 48 </a>    <span class="php-keyword1">private</span> <span class="php-var">$data</span>    = [];
</span><span id="49" class="l"><a href="#49"> 49 </a>
</span><span id="50" class="l"><a href="#50"> 50 </a>    <span class="php-comment">/**
</span></span><span id="51" class="l"><a href="#51"> 51 </a><span class="php-comment">     * Construction method
</span></span><span id="52" class="l"><a href="#52"> 52 </a><span class="php-comment">     *
</span></span><span id="53" class="l"><a href="#53"> 53 </a><span class="php-comment">     * @param \Slimore\Mvc\Model $model
</span></span><span id="54" class="l"><a href="#54"> 54 </a><span class="php-comment">     * @param $page
</span></span><span id="55" class="l"><a href="#55"> 55 </a><span class="php-comment">     * @param $total
</span></span><span id="56" class="l"><a href="#56"> 56 </a><span class="php-comment">     * @param int $num 10
</span></span><span id="57" class="l"><a href="#57"> 57 </a><span class="php-comment">     * @param int $range 6
</span></span><span id="58" class="l"><a href="#58"> 58 </a><span class="php-comment">     * @return void
</span></span><span id="59" class="l"><a href="#59"> 59 </a><span class="php-comment">     */</span>
</span><span id="60" class="l"><a href="#60"> 60 </a>
</span><span id="61" class="l"><a href="#61"> 61 </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> __construct(\Slimore\Mvc\Model <span class="php-var">$model</span>, <span class="php-var">$page</span>, <span class="php-var">$total</span>, <span class="php-var">$num</span> = <span class="php-num">10</span>, <span class="php-var">$range</span> = <span class="php-num">6</span>)
</span><span id="62" class="l"><a href="#62"> 62 </a>    {
</span><span id="63" class="l"><a href="#63"> 63 </a>        <span class="php-var">$this</span>-&gt;num   = <span class="php-var">$num</span>;
</span><span id="64" class="l"><a href="#64"> 64 </a>        <span class="php-var">$this</span>-&gt;page  = <span class="php-var">$page</span>;
</span><span id="65" class="l"><a href="#65"> 65 </a>        <span class="php-var">$this</span>-&gt;total = <span class="php-var">$total</span>;
</span><span id="66" class="l"><a href="#66"> 66 </a>        <span class="php-var">$this</span>-&gt;<span class="php-keyword2">range</span> = <span class="php-var">$range</span>;
</span><span id="67" class="l"><a href="#67"> 67 </a>        <span class="php-var">$this</span>-&gt;model = <span class="php-var">$model</span>;
</span><span id="68" class="l"><a href="#68"> 68 </a>        <span class="php-var">$this</span>-&gt;first = <span class="php-num">1</span>;
</span><span id="69" class="l"><a href="#69"> 69 </a>
</span><span id="70" class="l"><a href="#70"> 70 </a>        <span class="php-var">$this</span>-&gt;make();
</span><span id="71" class="l"><a href="#71"> 71 </a>    }
</span><span id="72" class="l"><a href="#72"> 72 </a>
</span><span id="73" class="l"><a href="#73"> 73 </a>    <span class="php-comment">/**
</span></span><span id="74" class="l"><a href="#74"> 74 </a><span class="php-comment">     * Make paginator params
</span></span><span id="75" class="l"><a href="#75"> 75 </a><span class="php-comment">     *
</span></span><span id="76" class="l"><a href="#76"> 76 </a><span class="php-comment">     * @return void
</span></span><span id="77" class="l"><a href="#77"> 77 </a><span class="php-comment">     */</span>
</span><span id="78" class="l"><a href="#78"> 78 </a>
</span><span id="79" class="l"><a href="#79"> 79 </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> make()
</span><span id="80" class="l"><a href="#80"> 80 </a>    {
</span><span id="81" class="l"><a href="#81"> 81 </a>        <span class="php-var">$this</span>-&gt;pageTotal = <span class="php-keyword2">ceil</span>(<span class="php-var">$this</span>-&gt;total / <span class="php-var">$this</span>-&gt;num);
</span><span id="82" class="l"><a href="#82"> 82 </a>        <span class="php-var">$this</span>-&gt;page      = (<span class="php-var">$this</span>-&gt;page &gt; <span class="php-var">$this</span>-&gt;pageTotal) ? <span class="php-var">$this</span>-&gt;pageTotal : <span class="php-var">$this</span>-&gt;page;
</span><span id="83" class="l"><a href="#83"> 83 </a>        <span class="php-var">$this</span>-&gt;offset    = (<span class="php-var">$this</span>-&gt;page == <span class="php-num">1</span>) ? <span class="php-num">0</span> : ((<span class="php-var">$this</span>-&gt;page - <span class="php-num">1</span>) * <span class="php-var">$this</span>-&gt;num);
</span><span id="84" class="l"><a href="#84"> 84 </a>        <span class="php-var">$this</span>-&gt;<span class="php-keyword2">prev</span>      = (<span class="php-var">$this</span>-&gt;page == <span class="php-num">1</span>) ? <span class="php-num">1</span> : <span class="php-var">$this</span>-&gt;page - <span class="php-num">1</span>;
</span><span id="85" class="l"><a href="#85"> 85 </a>        <span class="php-var">$this</span>-&gt;<span class="php-keyword2">next</span>      = (<span class="php-var">$this</span>-&gt;page == <span class="php-var">$this</span>-&gt;pageTotal) ? <span class="php-var">$this</span>-&gt;pageTotal : <span class="php-var">$this</span>-&gt;page + <span class="php-num">1</span>;
</span><span id="86" class="l"><a href="#86"> 86 </a>        <span class="php-var">$this</span>-&gt;last      = <span class="php-var">$this</span>-&gt;pageTotal;
</span><span id="87" class="l"><a href="#87"> 87 </a>
</span><span id="88" class="l"><a href="#88"> 88 </a>        <span class="php-var">$this</span>-&gt;<span class="php-keyword2">range</span>();
</span><span id="89" class="l"><a href="#89"> 89 </a>    }
</span><span id="90" class="l"><a href="#90"> 90 </a>
</span><span id="91" class="l"><a href="#91"> 91 </a>    <span class="php-comment">/**
</span></span><span id="92" class="l"><a href="#92"> 92 </a><span class="php-comment">     * Set/Get paginator ranges
</span></span><span id="93" class="l"><a href="#93"> 93 </a><span class="php-comment">     *
</span></span><span id="94" class="l"><a href="#94"> 94 </a><span class="php-comment">     * @return array
</span></span><span id="95" class="l"><a href="#95"> 95 </a><span class="php-comment">     */</span>
</span><span id="96" class="l"><a href="#96"> 96 </a>
</span><span id="97" class="l"><a href="#97"> 97 </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <span class="php-keyword2">range</span>()
</span><span id="98" class="l"><a href="#98"> 98 </a>    {
</span><span id="99" class="l"><a href="#99"> 99 </a>        <span class="php-var">$start</span> = <span class="php-var">$this</span>-&gt;page - <span class="php-var">$this</span>-&gt;<span class="php-keyword2">range</span>;
</span><span id="100" class="l"><a href="#100">100 </a>        <span class="php-var">$start</span> = (<span class="php-var">$start</span> &lt; <span class="php-num">1</span>) ? <span class="php-num">1</span> : <span class="php-var">$start</span>;
</span><span id="101" class="l"><a href="#101">101 </a>        <span class="php-var">$end</span>   = <span class="php-var">$this</span>-&gt;page + <span class="php-var">$this</span>-&gt;<span class="php-keyword2">range</span>;
</span><span id="102" class="l"><a href="#102">102 </a>        <span class="php-var">$end</span>   = (<span class="php-var">$end</span> &gt; <span class="php-var">$this</span>-&gt;pageTotal) ? <span class="php-var">$this</span>-&gt;pageTotal : <span class="php-var">$end</span>;
</span><span id="103" class="l"><a href="#103">103 </a>
</span><span id="104" class="l"><a href="#104">104 </a>        <span class="php-var">$this</span>-&gt;ranges = [
</span><span id="105" class="l"><a href="#105">105 </a>            <span class="php-quote">'start'</span>   =&gt; <span class="php-var">$start</span>,
</span><span id="106" class="l"><a href="#106">106 </a>            <span class="php-quote">'end'</span>     =&gt; <span class="php-var">$end</span>
</span><span id="107" class="l"><a href="#107">107 </a>        ];
</span><span id="108" class="l"><a href="#108">108 </a>
</span><span id="109" class="l"><a href="#109">109 </a>        <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;ranges;
</span><span id="110" class="l"><a href="#110">110 </a>    }
</span><span id="111" class="l"><a href="#111">111 </a>
</span><span id="112" class="l"><a href="#112">112 </a>    <span class="php-comment">/**
</span></span><span id="113" class="l"><a href="#113">113 </a><span class="php-comment">     * Reset model
</span></span><span id="114" class="l"><a href="#114">114 </a><span class="php-comment">     *
</span></span><span id="115" class="l"><a href="#115">115 </a><span class="php-comment">     * @param \Slimore\Mvc\Model $model
</span></span><span id="116" class="l"><a href="#116">116 </a><span class="php-comment">     * @return \Slimore\Mvc\Model $model
</span></span><span id="117" class="l"><a href="#117">117 </a><span class="php-comment">     */</span>
</span><span id="118" class="l"><a href="#118">118 </a>
</span><span id="119" class="l"><a href="#119">119 </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> model(\Slimore\Mvc\Model <span class="php-var">$model</span>)
</span><span id="120" class="l"><a href="#120">120 </a>    {
</span><span id="121" class="l"><a href="#121">121 </a>        <span class="php-var">$this</span>-&gt;model = <span class="php-var">$model</span>;
</span><span id="122" class="l"><a href="#122">122 </a>
</span><span id="123" class="l"><a href="#123">123 </a>        <span class="php-keyword1">return</span> <span class="php-var">$model</span>;
</span><span id="124" class="l"><a href="#124">124 </a>    }
</span><span id="125" class="l"><a href="#125">125 </a>
</span><span id="126" class="l"><a href="#126">126 </a>    <span class="php-comment">/**
</span></span><span id="127" class="l"><a href="#127">127 </a><span class="php-comment">     * Sql query
</span></span><span id="128" class="l"><a href="#128">128 </a><span class="php-comment">     *
</span></span><span id="129" class="l"><a href="#129">129 </a><span class="php-comment">     * @param bool $toJson
</span></span><span id="130" class="l"><a href="#130">130 </a><span class="php-comment">     * @return array
</span></span><span id="131" class="l"><a href="#131">131 </a><span class="php-comment">     */</span>
</span><span id="132" class="l"><a href="#132">132 </a>
</span><span id="133" class="l"><a href="#133">133 </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> query()
</span><span id="134" class="l"><a href="#134">134 </a>    {
</span><span id="135" class="l"><a href="#135">135 </a>        <span class="php-var">$model</span>       = <span class="php-var">$this</span>-&gt;model;
</span><span id="136" class="l"><a href="#136">136 </a>
</span><span id="137" class="l"><a href="#137">137 </a>        <span class="php-var">$this</span>-&gt;query = <span class="php-var">$model</span>-&gt;select(<span class="php-var">$this</span>-&gt;select)
</span><span id="138" class="l"><a href="#138">138 </a>                            -&gt;where(<span class="php-var">$this</span>-&gt;where)
</span><span id="139" class="l"><a href="#139">139 </a>                            -&gt;orderBy(<span class="php-var">$this</span>-&gt;orderBy, <span class="php-var">$this</span>-&gt;sortBy)
</span><span id="140" class="l"><a href="#140">140 </a>                            -&gt;take(<span class="php-var">$this</span>-&gt;num)
</span><span id="141" class="l"><a href="#141">141 </a>                            -&gt;offset(<span class="php-var">$this</span>-&gt;offset);
</span><span id="142" class="l"><a href="#142">142 </a>
</span><span id="143" class="l"><a href="#143">143 </a>        <span class="php-var">$this</span>-&gt;sql   = <span class="php-var">$this</span>-&gt;query-&gt;getQuery()-&gt;toSql();
</span><span id="144" class="l"><a href="#144">144 </a>
</span><span id="145" class="l"><a href="#145">145 </a>        <span class="php-var">$this</span>-&gt;data  = <span class="php-var">$this</span>-&gt;query-&gt;get()-&gt;toArray();
</span><span id="146" class="l"><a href="#146">146 </a>
</span><span id="147" class="l"><a href="#147">147 </a>        <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;data;
</span><span id="148" class="l"><a href="#148">148 </a>    }
</span><span id="149" class="l"><a href="#149">149 </a>
</span><span id="150" class="l"><a href="#150">150 </a>    <span class="php-comment">/**
</span></span><span id="151" class="l"><a href="#151">151 </a><span class="php-comment">     * @return mixed
</span></span><span id="152" class="l"><a href="#152">152 </a><span class="php-comment">     */</span>
</span><span id="153" class="l"><a href="#153">153 </a>
</span><span id="154" class="l"><a href="#154">154 </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getQuery()
</span><span id="155" class="l"><a href="#155">155 </a>    {
</span><span id="156" class="l"><a href="#156">156 </a>        <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;query;
</span><span id="157" class="l"><a href="#157">157 </a>    }
</span><span id="158" class="l"><a href="#158">158 </a>
</span><span id="159" class="l"><a href="#159">159 </a>    <span class="php-comment">/**
</span></span><span id="160" class="l"><a href="#160">160 </a><span class="php-comment">     * @return string
</span></span><span id="161" class="l"><a href="#161">161 </a><span class="php-comment">     */</span>
</span><span id="162" class="l"><a href="#162">162 </a>
</span><span id="163" class="l"><a href="#163">163 </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getSql()
</span><span id="164" class="l"><a href="#164">164 </a>    {
</span><span id="165" class="l"><a href="#165">165 </a>        <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;sql;
</span><span id="166" class="l"><a href="#166">166 </a>    }
</span><span id="167" class="l"><a href="#167">167 </a>
</span><span id="168" class="l"><a href="#168">168 </a>    <span class="php-comment">/**
</span></span><span id="169" class="l"><a href="#169">169 </a><span class="php-comment">     * @param bool $sql false
</span></span><span id="170" class="l"><a href="#170">170 </a><span class="php-comment">     * @return array
</span></span><span id="171" class="l"><a href="#171">171 </a><span class="php-comment">     */</span>
</span><span id="172" class="l"><a href="#172">172 </a>
</span><span id="173" class="l"><a href="#173">173 </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> params(<span class="php-var">$sql</span> = <span class="php-keyword1">false</span>)
</span><span id="174" class="l"><a href="#174">174 </a>    {
</span><span id="175" class="l"><a href="#175">175 </a>        <span class="php-var">$this</span>-&gt;params = [
</span><span id="176" class="l"><a href="#176">176 </a>            <span class="php-quote">'sql'</span>       =&gt; (<span class="php-var">$sql</span>) ? <span class="php-var">$this</span>-&gt;sql : <span class="php-quote">''</span>,
</span><span id="177" class="l"><a href="#177">177 </a>            <span class="php-quote">'num'</span>       =&gt; <span class="php-var">$this</span>-&gt;num,
</span><span id="178" class="l"><a href="#178">178 </a>            <span class="php-quote">'data'</span>      =&gt; <span class="php-var">$this</span>-&gt;data,
</span><span id="179" class="l"><a href="#179">179 </a>            <span class="php-quote">'page'</span>      =&gt; <span class="php-var">$this</span>-&gt;page,
</span><span id="180" class="l"><a href="#180">180 </a>            <span class="php-quote">'prev'</span>      =&gt; <span class="php-var">$this</span>-&gt;<span class="php-keyword2">prev</span>,
</span><span id="181" class="l"><a href="#181">181 </a>            <span class="php-quote">'next'</span>      =&gt; <span class="php-var">$this</span>-&gt;<span class="php-keyword2">next</span>,
</span><span id="182" class="l"><a href="#182">182 </a>            <span class="php-quote">'last'</span>      =&gt; <span class="php-var">$this</span>-&gt;last,
</span><span id="183" class="l"><a href="#183">183 </a>            <span class="php-quote">'first'</span>     =&gt; <span class="php-var">$this</span>-&gt;first,
</span><span id="184" class="l"><a href="#184">184 </a>            <span class="php-quote">'range'</span>     =&gt; <span class="php-var">$this</span>-&gt;<span class="php-keyword2">range</span>,
</span><span id="185" class="l"><a href="#185">185 </a>            <span class="php-quote">'total'</span>     =&gt; <span class="php-var">$this</span>-&gt;total,
</span><span id="186" class="l"><a href="#186">186 </a>            <span class="php-quote">'ranges'</span>    =&gt; <span class="php-var">$this</span>-&gt;ranges,
</span><span id="187" class="l"><a href="#187">187 </a>            <span class="php-quote">'offset'</span>    =&gt; <span class="php-var">$this</span>-&gt;offset,
</span><span id="188" class="l"><a href="#188">188 </a>            <span class="php-quote">'baseUrl'</span>   =&gt; <span class="php-var">$this</span>-&gt;baseUrl,
</span><span id="189" class="l"><a href="#189">189 </a>            <span class="php-quote">'pageTotal'</span> =&gt; <span class="php-var">$this</span>-&gt;pageTotal
</span><span id="190" class="l"><a href="#190">190 </a>        ];
</span><span id="191" class="l"><a href="#191">191 </a>
</span><span id="192" class="l"><a href="#192">192 </a>        <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;params;
</span><span id="193" class="l"><a href="#193">193 </a>    }
</span><span id="194" class="l"><a href="#194">194 </a>
</span><span id="195" class="l"><a href="#195">195 </a>    <span class="php-comment">/**
</span></span><span id="196" class="l"><a href="#196">196 </a><span class="php-comment">     * @param bool $sql true
</span></span><span id="197" class="l"><a href="#197">197 </a><span class="php-comment">     */</span>
</span><span id="198" class="l"><a href="#198">198 </a>
</span><span id="199" class="l"><a href="#199">199 </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> debug(<span class="php-var">$sql</span> = <span class="php-keyword1">true</span>)
</span><span id="200" class="l"><a href="#200">200 </a>    {
</span><span id="201" class="l"><a href="#201">201 </a>        Debug::printr(<span class="php-var">$this</span>-&gt;params(<span class="php-var">$sql</span>));
</span><span id="202" class="l"><a href="#202">202 </a>    }
</span><span id="203" class="l"><a href="#203">203 </a>
</span><span id="204" class="l"><a href="#204">204 </a>    <span class="php-comment">/**
</span></span><span id="205" class="l"><a href="#205">205 </a><span class="php-comment">     * @param bool $sql  true
</span></span><span id="206" class="l"><a href="#206">206 </a><span class="php-comment">     * @param bool $return  false
</span></span><span id="207" class="l"><a href="#207">207 </a><span class="php-comment">     */</span>
</span><span id="208" class="l"><a href="#208">208 </a>
</span><span id="209" class="l"><a href="#209">209 </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> json(<span class="php-var">$sql</span> = <span class="php-keyword1">true</span>, <span class="php-var">$return</span> = <span class="php-keyword1">false</span>)
</span><span id="210" class="l"><a href="#210">210 </a>    {
</span><span id="211" class="l"><a href="#211">211 </a>        Debug::json(<span class="php-var">$this</span>-&gt;params(<span class="php-var">$sql</span>), <span class="php-var">$return</span>);
</span><span id="212" class="l"><a href="#212">212 </a>    }
</span><span id="213" class="l"><a href="#213">213 </a>}</span></code></pre>
	</div>

	<div id="footer">
		Slimore API documentation generated by <a href="http://apigen.org">ApiGen</a>
	</div>
</div>
<script src="resources/combined.js?ff10aed8ecadcf22a036a1e06da72f663416f105"></script>
<script src="elementlist.js?01261a928428f5322e9a1f12c874f91987722d3a"></script>
</body>
</html>
